Problem Note 34457: Migrating from SAS® 9.1.3 to SAS® 9.2 might fail when a repository container data set has duplicate entries
 |  |  |  |
Migrating from SAS 9.1.3 to SAS 9.2 might fail when any repository container data set contains duplicate entries. The SAS® Metadata Server I/O subsystem will return the following error message in a dialog box:
ERROR: You cannot delete TMP002.MDASSOC.DATA because TMP002.MDASSOC.DATA is in use by you in resource environment Object Server.'. Contact the SAS Metadata Server administrator for assistance. Note: TMP002 is a repository reference and MDASSOC could be any container data set in the repository.
The \SAS\config directory\Lev1\Logs\Configure\UpgradeMetadata_n.log file contains details regarding the failing repository that are similar to those which follow:
[MetadatasrvMigrate] [UpgradeMetadataServer] 16:03:45 INFO Upgrading 6 repositories. [MetadatasrvMigrate] [UpgradeMetadataServer] 16:04:09 ERROR com.sas.management.metadata.UpgradeException: Error during repository model upgrade. [MetadatasrvMigrate] [UpgradeMetadataServer] at com.sas.management.metadata.RepositoryUpgrade2.upgradeRepositoryModel (RepositoryUpgrade2.java:116) [MetadatasrvMigrate] [UpgradeMetadataServer] at com.sas.management.metadata.UpgradeDriver2.upgrade(UpgradeDriver2.java:158) [MetadatasrvMigrate] [UpgradeMetadataServer] at com.sas.management.metadata.UpgradeDriver2.main(UpgradeDriver2.java:280) [MetadatasrvMigrate] [UpgradeMetadataServer] Caused by: com.sas.metadata.remote.MdException: The SAS Metadata Server I/O subsystem has returned error message ' ERROR: You cannot delete TMP002.MDASSOC.DATA because TMP002.MDASSOC.DATA is in use by you in resource environment Object Server.'. Contact the SAS Metadata Server administrator for assistance. [MetadatasrvMigrate] [UpgradeMetadataServer] 16:04:09 ERROR The upgrade process has completed with errors. [MetadatasrvMigrate] [UpgradeMetadataServer] 16:04:09 INFO The upgrade log is saved to C:\SAS\EBIEDIEG\Lev1\Logs\Configure\UpgradeMetadata_081204160341.log [MetadatasrvMigrate] ERROR: Metadata upgrade reported fatal errors with return code 16. Migration has failed. See C:\SAS\EBIEDIEG\Lev1 \Logs\Configure\UpgradeMetadata_081204160341.log for details. [MetadatasrvMigrate] ERROR: Metadata upgrade reported fatal errors with return code 16. Migration has failed. See C:\SAS\EBIEDIEG\Lev1 \Logs\Configure\UpgradeMetadata_081204160341.log for details. [MetadatasrvMigrate] Closed metadata server connection. [antcall] Exiting C:\Program Files\SAS\SASFoundation\9.2 \core\sasmisc\sasconf\metadatasrv\config\metadatasrv_config.xml.
To circumvent this problem, open the CNTAINER data set or the data set in the error message that is located in the migration package, using either SAS 9.1.3 or SAS 9.2. Remove any duplicate records and rerun the migration. If the duplicates can be easily found, all records with PERSIST in the CRMETHOD column can be deleted safely.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M0 | ||
| z/OS | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M0 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Linux | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | System Administration ==> Migration System Administration ==> Servers ==> Metadata |
| Date Modified: | 2009-03-06 10:30:58 |
| Date Created: | 2009-01-12 15:52:15 |